package com.atguigu.tingshu.album.mapper;

import com.atguigu.tingshu.model.album.TrackInfo;
import com.atguigu.tingshu.query.album.TrackInfoQuery;
import com.atguigu.tingshu.vo.album.AlbumTrackListVo;
import com.atguigu.tingshu.vo.album.TrackListVo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface TrackInfoMapper extends BaseMapper<TrackInfo> {


    //查询声音
    IPage<TrackListVo> selectUserTrackPage(Page<TrackListVo> trackListVoPage, @Param("vo") TrackInfoQuery trackInfoQuery);

    //删除声音数据之后,重新修改专辑排序,就一行sql语句,可以直接用注解实现
    @Update("update track_info set order_num=order_num-1 where album_id=#{albumId} and order_num > #{orderNum} and is_deleted=0")
    int updateOrderNum(@Param("albumId") Long albumId, @Param("orderNum") Integer orderNum);

    /**
     * 根据专辑ID获取专辑声音列表
     *
     * @param albumTrackListVoPage
     * @param albumId
     * @return
     */
    @Select("select\n" +
            "       track.id  track_id,\n" +
            "       track.track_title,\n" +
            "       track.media_duration,\n" +
            "       track.order_num,\n" +
            "       max(case when stat.stat_type = '0701' then stat.stat_num else 0 end) playStatNum,\n" +
            "       max(case when stat.stat_type = '0704' then stat.stat_num else 0 end) commentStatNum,\n" +
            "       track.create_time\n" +
            "from track_info track\n" +
            "         inner join track_stat stat on track.id = stat.track_id\n" +
            "where track.album_id = #{albumId}\n" +
            "  and track.status = '0501'\n" +
            "  and track.is_deleted = 0\n" +
            "group by track.id")
    IPage<AlbumTrackListVo> selectAlbumTrackList(Page<AlbumTrackListVo> albumTrackListVoPage,@Param("albumId") Long albumId);

    /**
     * 修改声音播放统计数据
     * @param count
     * @param trackId
     * @param statType
     */
    @Update("update track_stat set stat_num=stat_num + #{count} where track_id=#{trackId} and stat_type=#{statType} and is_deleted=0")
    int updateTrackStat(@Param("count") Integer count,@Param("trackId") Long trackId,@Param("statType") String statType);

}
